select * from products where pro_name like '%Spring%dresses%' or pro_des like '%Spring%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%dresses%' or pro_des not like '%Spring%dresses%')

2015 Cheap and Cute Lilac Beading Sweetheart Dama Dresses with Pick Ups

Cheap Dark Green Sweetheart Dama Dresses with Beading and Appliques

Cheap Ball Gown Pink and Black Strapless Dama Dresses with Appliques and Ruffles

2015 Cheap Red Strapless Dama Dresses with Beading and Hand Made Flower

Cheap High Low Sweetheart Wine Red Beading Dama Dresses

New Sweetheart Sweep Train Beading and Ruffles Princesita Dress for 2015

Popular Beading and Ruffles Red Princesita Dress for 2015

Wonderful Embroidery and Ruffles 2015 Princesita Dress in Pink

Sequins and Ruffles Ball Gown 2015 White Princesita Dress

Latest Appliques Princesita Dress in Light Yellow For 2015

Simple Sweetheart Sequins Princesita Dress in Rose Pink For 2015

2015 Elegant Appliques and Ruffles Princesita Dress in Baby Blue

2015 Appliques and Ruffles Lilac Princesita Dress with Hand Made Flowers

2015 Top Selling Wedding Shawl with Open Front

Ivory Faux Fur Shawl With Button Front Closure

2015 Beautiful Rabbit Fur Shawls with Rhinestone

Pearl Front Closure Rabbit Fur 2015 Pretty Shawls

2015 The Most Popular White Wraps with Faux Fur

Faux Fur Open Front Shawls for Wedding Party

2015 Perfect Open Front Wraps with Faux Fur

2015 Ivory Faux Fur Shawl With Button Front Closure

2015 Elegant Open Front Wraps for Wedding Party

Open Front 2015 Wonderful Shawls in White

Fox Fringed Fur 2015 Remarkable Wraps with Button

Modern Pearl Front Closure Faux Fur Wraps for 2015

Fold over Collar Special Occasion Rabbit Fur Shawls

2015 White Rabbit Fur Shawls with Long Sleeves

Long Sleeves 2015 Popular Shawls in White

2015 High Quality Bridal Shawl with Open Front

Top Selling Open Front Wraps in White